java 数据库

一头呆鹅 2011-07-13 11:30:58

window 下不配置数据源
java 如何连接数据库，菜鸟
下面是我的 DbManager：：：

package com.helloworldpro.action;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class DbManager {

public static String findAll(){
String sql="select *from images";
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:sqlserver";
String userName="sa";
String userPass="sa";
StringBuffer buf = new StringBuffer("<slides>");
try {
Class.forName(driver);
Connection conn=DriverManager.getConnection(url,userName,userPass);
PreparedStatement pstm=conn.prepareStatement(sql);
ResultSet rs=pstm.executeQuery();
while(rs.next()){
String imagePath=rs.getString(3);
buf.append("<slide name='"+imagePath.trim()+"' />");

}
rs.close();
pstm.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
buf.append("</slides>");
return buf.toString();
}

public static void insert(String imageId,String imageName,String imagePath,String imageDes){
try {
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:sqlserver";
String userName="sa";
String userPass="sa";
Class.forName(driver);
Connection conn=DriverManager.getConnection(url,userName,userPass);
String sql="insert into images values (?,?,?,?)";
PreparedStatement pstm=conn.prepareStatement(sql);
pstm.setString(1, imageId);
pstm.setString(2, imageName);
pstm.setString(3, imagePath);
pstm.setString(4, imageDes);
pstm.executeUpdate();
pstm.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
// public static void main(String[] args) {
// DbManager db=new DbManager();
// //db.insert("2", "第二个小新", "xiaoxin/hello.jpg", "哈哈哈哈哈哈哈哈");
// String str=DbManager.findAll();
// System.out.println(str);
// }
}

...全文