MS SQL Server 2008上与数据库的连接出现问题。编译器给了我以下错误" "="附近的语法不正确;找不到myfelf的任何错误。如果有人帮助我,会很高兴。
所以,这是代码:
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package sklad;
import java.sql.*;
import javax.swing.*;
/**
*
* @author Имба
*/
public class conexion {
// private static final String JDBCDriver ="com.microsoft.sqlserver.jdbc.SQLServerDriver";
// private static final String ConnectionStr = "jdbc:sqlserver:/localhost:1433;user=sa;password=asdf;databaseName = StoreDB";
public String user = "sa";
public String password = "asdf";
public String url = "jdbc:sqlserver://localhost:1433;
databaseName=StoreDB";
public Connection cn = null;
public Statement st = null;
public Statement Conectar()
{
try
{
Connection cn = DriverManager.getConnection(url,user,password);
st=cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
}
catch (SQLException i)
{
JOptionPane.showMessageDialog(null, i);
}
return st;
}
}
把它放在一行中,没有换行符......
public String url = "jdbc:sqlserver://localhost:1433;databaseName=StoreDB";
首先将url
放在一行上,如下所示:
public String url = "jdbc:sqlserver://localhost:1433;databaseName=StoreDB";
Java 不允许多行字符串文字。
除此之外,这个类是糟糕的设计,因为它不会自行清理。