jdbc我已经配置好了,需要配置web.xml文件吗?怎样配置?
具体的java语句应该如何写?最好能举一个具体的例子,谢谢
具体的java语句应该如何写?最好能举一个具体的例子,谢谢
解决方案 »
- 求java 各种排序算法 得出每步排序结果的程序
- 一个类里面的定义对象可以是接口吗?
- JAVA调用MySQL存储过程跟SQL2000一样吗?(高手们帮帮忙吧.跪求了,急用)
- 有关类反回参数问题
- 【全美经典】 Java 编程习题与解答(中文版,[美] John R.Hubbard 著)
- jmx agent能否动态load一个mbean,怎样做 谢谢
- 如何动态加载jar中的类
- 在java.io.DataInputStream中的readLine()已经不提倡使用?
- 我想用JNI传递一个类,遇到了麻烦。
- String a="123"与String a=new String("123")出来的两个a,b之间有什么区别???
- 关于变量的问题!!
- 一个泛型的知识点,我实在搞不懂,麻烦各位帮我解答下,谢谢!
给你一个简单的小例子 import java.sql.*;public class mytest { /**
* @param args
* @throws ClassNotFoundException
* @throws IllegalAccessException
* @throws InstantiationException
* @throws SQLException
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
String drivers = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String username ="sa";
String password ="sa";
String sql="select * from authors;";
try{
Class.forName(drivers).newInstance();
Connection con=DriverManager.getConnection(url,username,password);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
}
stmt.close();
con.close();
}
catch(java.lang.Exception e)
{
e.printStackTrace();
}
}
}
给你一个通用的连接bean吧
package com.database;import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;/**
* @author mwq
*
*/
public class JDBC { private static final String DRIVERCLASS = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; protected final String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=你数据库的名字"; protected final String username = "sa"; protected final String password = "xxx"; protected Connection conn; protected Statement stmt; protected PreparedStatement prpdStmt; protected CallableStatement cablStmt; protected ResultSet rs; static {
try {
Class.forName(DRIVERCLASS);
} catch (ClassNotFoundException e) {
System.out.println("------ 在加载数据库驱动时抛出异常,内容如下:");
e.printStackTrace();
}
} public boolean openConn(boolean autoCommit) {
boolean isOpen = true;
try {
conn = DriverManager.getConnection(url, username, password);
if (!autoCommit)
conn.setAutoCommit(false);
} catch (SQLException e) {
isOpen = false;
System.out.println("------ 在创建数据库连接时抛出异常,内容如下:");
e.printStackTrace();
}
return isOpen;
} public boolean closeConn() {
boolean isCommit = true;
try {
conn.commit();
} catch (SQLException e) {
isCommit = false;
System.out.println("------ 在提交数据库事务时抛出异常,内容如下:");
e.printStackTrace();
try {
conn.rollback();
} catch (SQLException e1) {
System.out.println("------ 在回滚数据库事务时抛出异常,内容如下:");
e1.printStackTrace();
}
} finally {
try {
conn.close();
} catch (SQLException e) {
System.out.println("------ 在关闭数据库连接时抛出异常,内容如下:");
e.printStackTrace();
}
}
return isCommit;
}}
import java.awt.event.*;
import java.awt.*;
import java.sql.*;
public class fwin extends JFrame implements ActionListener{
JTable table;
JButton b1,b2,b3,b4;
Object a[][];
Connection con;
Statement sql;
ResultSet rs;
Object columnName[]={"学号","姓名","数学","英语"};
fwin(){
super("数据库查询");
a=new Object[60][4];
table=new JTable(a,columnName);
setSize(500,500);
b1=new JButton("浏览表");
b2=new JButton("排序查询");
b3=new JButton("模糊查询");
b4=new JButton("退出");
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
b4.addActionListener(this);
Container con=getContentPane();
con.setLayout(new FlowLayout());
con.add(b1);
con.add(b2);
con.add(b3);
con.add(b4);
Container container=getContentPane();
container.add(new JScrollPane(table),BorderLayout.CENTER);
setVisible(true);
validate();
addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent ev){
System.exit(0);
}
});
}
int i=0;
public void actionPerformed(ActionEvent ev){
if(ev.getSource()==b1){
while(i>=0){
a[i][0]=" ";
a[i][1]=" ";
a[i][2]=" ";
a[i][3]=" ";
i--;
}
i=0;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
System.out.println("链接不上");
}
try{
con=DriverManager.getConnection("jdbc:odbc:demo","test","123");
sql=con.createStatement();
rs=sql.executeQuery("Select * From biao");
while(rs.next()){
String number=rs.getString("学号");
String name=rs.getString("姓名");
int math=rs.getInt("数学");
int eng=rs.getInt("英语");
a[i][0]=number;
a[i][1]=name;
a[i][2]=String.valueOf(math);
a[i][3]=String.valueOf(eng);
i++;
}
con.close();
repaint();
}catch(SQLException e){
System.out.println("出错了");}
}
else if(ev.getSource()==b2){
while(i>=0){
a[i][0]="";
a[i][1]="";
a[i][2]="";
a[i][3]="";
i--;
}
i=0;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){}
try{
con=DriverManager.getConnection("jdbc:odbc:demo","test","123");
sql=con.createStatement();
rs=sql.executeQuery("select * from biao order by 数学");
while(rs.next()){
String number=rs.getString("学号");
String name=rs.getString("姓名");
int math=rs.getInt("数学");
int eng=rs.getInt("英语");
a[i][0]=number;
a[i][1]=name;
a[i][2]=String.valueOf(math);
a[i][3]=String.valueOf(eng);
i++;
}
con.close();
repaint();
}catch(SQLException e){}
}
else if(ev.getSource()==b3){
while(i>=0){
a[i][0]="";
a[i][1]=" ";
a[i][2]=" ";
a[i][3]=" ";
i--;
}
i=0;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){}
try{
con=DriverManager.getConnection("jdbc:odbc:demo","test","123");
sql=con.createStatement();
rs=sql.executeQuery("select * from biao where 姓名 like '王%'");
while(rs.next()){
String number=rs.getString("学号");
String name=rs.getString("姓名");
int math=rs.getInt("数学");
int eng=rs.getInt("英语");
a[i][0]=number;
a[i][1]=name;
a[i][2]=String.valueOf(math);
a[i][3]=String.valueOf(eng);
i++;
}
con.close();
repaint();
}catch(SQLException e){}
}
else if(ev.getSource()==b4){
dispose();
}}
public static void main(String[] args){
fwin fw=new fwin();}
}
我是先建立了一个学生的数据库,里面有张叫biao的表,用户名为test,密码为123。
我在websphere上已经配置好jdbc和数据源了,用户名和密码也写上了,测试连接成功。
这样我在java文件里也需要写用户名和密码等这么详细的信息吗?
不懂 我也学学 帮你顶了