JDBC如何在一个数据库中新建一张表? <<Statement stat = conn.createStatement();stat.execute("create table tttt (id int)");>>这样就可以。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 完整例子,执行那里换成sql就是创建存储过程import java.sql.*;public class CreateProduce { public static void main(String[] args) { CreateProduce c = new CreateProduce(); c.createProduce(); } public void createProduce() { Connection conn = null; Statement stmt = null; PreparedStatement pstmt = null; try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); conn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=tt", "sa",""); if (conn.getMetaData().supportsStoredProcedures()) { System.out.println("support procedure"); } stmt = conn.createStatement(); String sql = "CREATE PROCEDURE getMutilinfo AS " + "BEGIN " + " SELECT * FROM customer; " + " SELECT * FROM ownerinfo; " + "END"; String sql1 = "Create table aa(id int, name varchar(20))"; int result = stmt.executeUpdate(sql1); if (result == 0) { System.out.println("Procedure created successfully"); } stmt.close(); conn.close(); } catch(Exception e) { System.out.println("Procedure Not Created"); e.printStackTrace(); } }} htmlparser爬虫 只能爬取到部份网页内容 高手进进进!!deploy.wsdd 问题 WEB WORK2.1.7在哪儿下载呀,具体有什么用?? 数据大问题 请教大虾!! 谁有J2EE SDK Samples 1.4 ?从sun网站下载的? apache和tomcat的整合意义何在 第二轮面试顺利通过,谢各位版友(2)... JDBC中大批量数据的查询中速度问题 高分,国内weblogic下载,!!!!在线..急... JNDI使用RMI连接数据库,要作如何设置才能将对象名绑定到数据库上 jdbc连接和游标问题
import java.sql.*;
public class CreateProduce { public static void main(String[] args)
{
CreateProduce c = new CreateProduce();
c.createProduce();
}
public void createProduce()
{
Connection conn = null;
Statement stmt = null;
PreparedStatement pstmt = null;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=tt",
"sa","");
if (conn.getMetaData().supportsStoredProcedures())
{
System.out.println("support procedure");
}
stmt = conn.createStatement();
String sql = "CREATE PROCEDURE getMutilinfo AS " +
"BEGIN " +
" SELECT * FROM customer; " +
" SELECT * FROM ownerinfo; " +
"END";
String sql1 = "Create table aa(id int, name varchar(20))";
int result = stmt.executeUpdate(sql1);
if (result == 0)
{
System.out.println("Procedure created successfully");
}
stmt.close();
conn.close();
}
catch(Exception e)
{
System.out.println("Procedure Not Created");
e.printStackTrace();
}
}
}